Write a MongoDB query to update specific fields in multiple documents in a collection.

Question

Aryan Kumar · Answer

Sure, here is a MongoDB query to update specific fields in multiple documents in a collection:
db.collection.updateMany({ name: 'John Doe' }, { $set: { age: 35, address: '123 Main Street' } });
This query updates the age and address fields in all documents in the collection where the
name field is equal to John Doe. The $set operator is used to update the fields, and the values of the fields are specified in the object literal.
For example, if the collection contains the following documents:
{ name: 'John Doe', age: 30, address: '456 Elm Street' }
{ name: 'Jane Doe', age: 25, address: '789 Oak Street' }
Then, the query would update the age and address fields in the first document to 35 and
123 Main Street, respectively. The second document would not be updated, because the
name field does not match the filter.
To run this query, you would need to connect to the MongoDB database and get the collection. Then, you could execute the query using the
updateMany() method.
Here is an example of how you could run the query:
const client = new MongoClient('mongodb://localhost:27017/mydb');
const db = client.db('mydb');
const collection = db.collection('people');
collection.updateMany({ name: 'John Doe' }, { $set: { age: 35, address: '123 Main Street' } });
This code would connect to the MongoDB database and get the people collection. Then, it would execute the query to update the
age and address fields in the document where the 
name field is equal to John Doe.

forum

Write a MongoDB query to update specific fields in multiple documents in a collection.

Steilla Mitchel

1 Answers

Liked By